CREATE TABLE [task_info] (
[jobname] varchar(200) NOT NULL,
[markversion] varchar(100) NOT NULL,
[jobid] uniqueidentifier NOT NULL,
[sourcetable] varchar(100) NOT NULL,
[targettable] varchar(100) NOT NULL,
[queuename] varchar(100) NOT NULL,
[updatetime] datetime NOT NULL,
[cron] varchar(50) NULL,
[mapping] varchar(MAX) NULL,
[processtime] datetime NULL);


CREATE TABLE [dbo].[task_log] (
[taskname] varchar(50) NOT NULL,
[taskid] uniqueidentifier NOT NULL,
[executetime] datetime NOT NULL,
[beginstamp] varchar(100) NOT NULL,
[endstamp] varchar(100) NOT NULL,
[amount] numeric(18, 0) NULL);